team_git_star_assignment4

Research questions:

Section 1 - Table 1 - [ ] For each LGA , which police region recorded maximum incidents? - [ ] How did the trend of incidents recorded in those police regions varied across the years.

Section 2

• For each LGA , which offence_subdivision, recorded maximum incidents

The offence_subdivision of maximum incidents in each LGA

The offence_subdivision of maximum incidents in each LGA

• For each LGA,Which offence_subgroup was most recorded in the previous found offence_subdivision’s?

The trend of each offence_subdivision

• What was the trend of each offence_subgroup found over the years?

The trend of each offence_subdivision

Section 3

• For each Suburb/Town, which offence_subdivision, recorded maximum incidents
• For each Suburb/Town,Which offence_subgroup was most recorded in the previous found offence_subdivision’s?